UBB.Developers Forums UBB.threads 7 Development Addons and Modifications [7.0.x] Forum Stats: Posts in the last 24 hours.

// Get last Total Posts for Last 24hrs 
// get the current timestamp into an array
$timestamp = time();
// echo strftime('%Hh%M %A %d %b',$timestamp);
// echo '<p>';
$date_time_array = getdate($timestamp);

$hours = $date_time_array['hours'];
$minutes = $date_time_array['minutes'];
$seconds = $date_time_array['seconds'];
$month = $date_time_array['mon'];
$day = $date_time_array['mday'];
$year = $date_time_array['year'];

// use mktime to recreate the unix timestamp
// adding 19 hours to $hours
$timestamp = mktime($hours - 29,$minutes,$seconds,$month,$day,$year);
// echo strftime('%Hh%M %A %d %b',$timestamp);
// echo '<br>~E after subtracting 29 hours';

$query = "
select count(*)
from {$config['TABLE_PREFIX']}POSTS
WHERE POST_POSTED_TIME > $timestamp
";
$sth = $dbh->do_query($query);
list($new_posts) = $dbh->fetch_array($sth);

$query = "
select count(USER_ID)
from {$config['TABLE_PREFIX']}USERS
where USER_IS_APPROVED = 'yes'
and USER_ID > 1
";
$sth = $dbh->do_query($query);
list($users) = $dbh->fetch_array($sth);

$ubbt_lang['NEW_POSTS'] = "Posts in 24rs";

$ubbt_lang['USERS'] = "Members";

<b>{$new_posts}</b> {$lang.NEW_POSTS}

<b>{$users}</b> {$lang.USERS}

// Get last Total Posts for Last 24hrs 
// get the current timestamp into an array
$timestamp = time();
// echo strftime('%Hh%M %A %d %b',$timestamp);
// echo '<p>';
$date_time_array = getdate($timestamp);

$hours = $date_time_array['hours'];
$minutes = $date_time_array['minutes'];
$seconds = $date_time_array['seconds'];
$month = $date_time_array['mon'];
$day = $date_time_array['mday'];
$year = $date_time_array['year'];

// use mktime to recreate the unix timestamp
// adding 19 hours to $hours
$timestamp = mktime($hours - 29,$minutes,$seconds,$month,$day,$year);
// echo strftime('%Hh%M %A %d %b',$timestamp);
// echo '<br>~E after subtracting 29 hours';

$timestamp = time() - 86400;